CREATE TABLE [dbo].[GroupInstanceRole]
(
[GroupKey] [uniqueidentifier] NOT NULL,
[GroupRoleKey] [uniqueidentifier] NOT NULL,
[IsUnique] [bit] NOT NULL CONSTRAINT [DF_GroupInstanceRole_IsUnique] DEFAULT ((0)),
[IsRequired] [bit] NOT NULL CONSTRAINT [DF_GroupInstanceRole_IsRequired] DEFAULT ((0)),
[IsDefault] [bit] NOT NULL CONSTRAINT [DF_GroupInstanceRole_IsDefault] DEFAULT ((0)),
[SortRank] [int] NULL,
[DefaultMemberStatusCode] [nvarchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GroupInstanceRoleKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[GroupInstanceRole] ADD CONSTRAINT [PK_GroupInstanceRole] PRIMARY KEY CLUSTERED ([GroupInstanceRoleKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GroupInstanceRole] ADD CONSTRAINT [AK_GroupInstanceRole] UNIQUE NONCLUSTERED ([GroupKey], [GroupRoleKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GroupInstanceRole_DefaultMemberStatusCode] ON [dbo].[GroupInstanceRole] ([DefaultMemberStatusCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GroupInstanceRole] ADD CONSTRAINT [FK_GroupInstanceRole_GroupMain] FOREIGN KEY ([GroupKey]) REFERENCES [dbo].[GroupMain] ([GroupKey])
GO
ALTER TABLE [dbo].[GroupInstanceRole] ADD CONSTRAINT [FK_GroupInstanceRole_GroupMemberStatusRef] FOREIGN KEY ([DefaultMemberStatusCode]) REFERENCES [dbo].[GroupMemberStatusRef] ([GroupMemberStatusCode])
GO
ALTER TABLE [dbo].[GroupInstanceRole] ADD CONSTRAINT [FK_GroupInstanceRole_GroupRoleRef] FOREIGN KEY ([GroupRoleKey]) REFERENCES [dbo].[GroupRoleRef] ([GroupRoleKey])
GO